The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / finacial / pfroi / pfroisw.exe / PFROISW1.HLP < prev next >

Wrap

Text File | 1992-08-21 | 22.9 KB | 462 lines

* PFROI 0 PFROI ("PortFolio Return On Investment") is an investment portfolio 0 management program designed to allow the user to maintain continuous 0 and contiguous records of all portfolio transactions, keep track of 0 investment cost bases for tax purposes, and to calculate portfolio 0 performance using the internal rate of return method of return on 0 investment ("ROI") calculation. Built-in communications facilitate 0 price quote downloading from a number of services. Prices may also 0 be manually entered or imported. PFROI additionally generates numerous 0 user-configurable reports, including graphics displays designed to 0 operate on CGA, EGA, VGA, and Hercules-type display systems. 0 0 PFROI uses two types of menu systems to enable the user to manuever 0 through the program. The first is a standard full-screen menu from 0 which a selection is made by keying a character at the ">" prompt. 0 The second type of menu system is an "Alt-Command" menu system. In this 0 system the available commands are displayed on a single line in mnemonic 0 form. The user executes the command by depressing the "Alt" key in 0 combination with the letter key corresponding to the selected command. 0 0 PFROI additionally uses the "Esc", "Arrow", "Page", "Ins", "Del", "Home" 0 and "End" keys plus some "Control-Key" combinations to perform editing 0 and screen manuevering functions. * General Commands 0 The following commands function much the same throughout the program: 0 0 Esc - Returns to the previous screen or aborts an operation 0 Arws - "Arrow" keys on number keypad move the cursor 0 PgUp - Pages upward (backward) a page of data at a time 0 PgDn - Pages downward (forward) a page of data at a time 0 ^PgUp - ("Ctrl" + "PgUp") Moves to start of data 0 ^PgDn - Moves to end of data 0 Ins - Inserts new record (Ctl+F5 duplicates record) 0 Del - Deletes current record (Ctl+F10 bypasses prompt message) 0 Home - Moves cursor to beginning of field, initiates field edit 0 End - Moves cursor to end of field, initiates field edit 0 ^Y - ("Ctrl"+"Y") Clears field 0 ^G - ("Ctrl"+"G") Deletes next word in field 0 Alt+F - File save, load and directory function sub-menu. 0 Alt+H - Displays help screen (or "F1" key) 0 Alt+P - Prints out data, "LPT1" is the default output device. If a 0 filename is used, a disk text file is created. 0 Output to "SCRN" enables output to be viewed on screen. 0 0 Other "Alt" commands vary functions depending upon the active screen. * PFROI Menu 0 0 Load Portfolio - Loads file specified, and then returns to main menu 0 with filename displayed in header. If specified file contains 0 non-portfolio records, file will be renamed to "XXXXXXXX.ZZZ" 0 to protect agains inadvertant corruption of non-portfolio files. 0 0 Transactions - Enters transaction module. This module is where "Buy", 0 "Sell", "Dividend", etc., activity is entered into your portfolio. 0 0 Valuations - Enters valuation module. The valuation module screen 0 indicates the dates for which portfolio position records have been 0 computed. Existing positions can be reviewed using the "Review" 0 (Alt+R) command. New positions may be added or existing positions 0 recomputed by using the "Create" (Alt+C) command. 0 0 Performance - Enters Return On Investment (ROI) computation module. 0 ROI "Start" and "End" dates should be existing valuation dates. 0 0 Reports - Enters report module. Many reports require a "Close Date" 0 which must be the date of an existing valuation. * PFROI MENU (Cont'd) 0 0 Client Group - Enters module for maintaining a list of portfolios being 0 managed. "Batch" valuations must be initiated from this module 0 and operate only on portfolios files listed in the currently 0 loaded client group file. 0 0 Auxiliaries - Access point for supporting records: 0 Portfolio Configuration 0 Tax Rate Records 0 Target Prices 0 Master Security List 0 Price History Records 0 Distribution Records (Regis PFROI/CAPTOOL) 0 Currency Exchange Rate Records (CAPTOOL Only) 0 0 Configure - Configuration menu for CAPTOOL/PFROI operating parameters. 0 0 Utilities - Accesses sub-programs which perform "merge", "archive", 0 "symbol change" and other functions. * Transaction "Alt" Menu 1 1 Alt+S - "Sorts" transactions by date. 1 Alt+A - accesses "Auxiliary" records menu. 1 Alt+M - toggles "Mask". Isolates transactions by "TAC", "Symbol" and "L#" 1 depending on which field in which cursor resides. Clear the mask 1 by toggling Alt+M a second time while the cursor is in the field. 1 Alt+D - toggles Display formats ("Est. Tax", "Cost/Unit", "Com/Fees") 1 Alt+C - various functions depending on field in which executed: 1 Descrip: Imports discription from master list 1 Amount : Calcs accrued interest for AMT, ACR & PIN transactions 1 Est tax: Calcs estimated taxes from current year forward 1 Alt+K - "seeK" record with next occurance of Symbol specified 1 Alt+T - "subTotals" a group of transactions. (toggle/move/toggle) 1 Alt+3 - "subtotals" quantity only transactions (signs adjusted) 1 Alt+4 - "subtotals" cash only transactions (signs adjusted) 1 Alt+I - Import transactions from text file (see manual for details) 1 (See IMPORT.TXT for details on importing from other portfolio mgrs.) 1 Alt+B - displays cash Balance at current transaction 1 Alt+G - toggle auto-siGn (careful! should be "On" excepting rare cases) 1 * Transaction Codes (TAC's) 1 DPF DePosit Funds CGD Capital Gains Distrib. (long) 1 WDF WithDraw Funds CGR Cap. Gains Dist. Reinvested 1 BUY BUY security CGW Cap. Gains Withdrawn 1 SLL SeLL security ROC Return Of Capital (credit cash) 1 SLS SelL Short RCR Return of Capital Reinvested 1 BYC BuY to cover RCW Return of Capital Withdrawn 1 IN+ INterest earned BRW BoRroW funds 1 IN- INterest paid RPY RePaY funds 1 DV+ DiVidend earned RNT ReNT earned 1 DV- DiVidend paid EXP cash EXPenses 1 SP+ Split credited DPR DePReciation 1 SP- Split debited RCV ReCieVe (e.g. from other portfolio) 1 INW Interest Withdrawn DLV DeLiVer (e.g. to other portfolio) 1 DVW Dividend Withdrawn FEE acct. mgmt. FEE ("FUI" for Fee UnInvest) 1 DRI Dividend ReInvested SCO/LCO Short/Long loss CarryOver 1 IRI Interest ReInvested SGD Short term cap. Gains Distrib. 1 BYD BuY + Deposit SGR Short term Gains distr. Reinvested 1 SLW SelL + Withdraw SGW Short term Gains distr. withdrawn 1 DST partnership DiSTrib PIN Phantom INterest 1 CBA Cost Base Ajustment AMT AMorTization of premium 1 IOB Interest On cash Bal ACR ACcRetion of discount (same as PIN) 1 TXW Taxes Withheld (on foreign dividends) * Transaction Fields 1 1 Mo/Dy/Yr - Transaction Date 1 TAC - Transaction Code 1 Symbol - Security trade symbol 1 Lot - Lot number (1..999, FFO, LFO, AVG, AV2) 1 Descrip. - Security Description 1 Quantity - # Shares (decimal shrs ok) 1 Amount - net transaction value (include commis. & fees) 1 Est. Tax - Estimated Taxes (for ROI calcs) 1 Cost/Unit- Computed cost/unit (non-input field) 1 Com.Fees - Commissions or fees 1 1 Descrip. field may contain note of : 1 div/int rate : "@$2.65" 1 receive date/amt : "&&3/15/85 $2435.25" (RCV only) 1 maturity date : "##1/15/92" 1 turn off cost cum : "=C-" 1 force "Long" posit: "=L+" * Position "Alt" Menu 2 2 Alt+T - computes "sub-Totals" (Normally, S/T's are automatically computed 2 upon price entry. "T-" in Misc. Specs. supresses automatic S/T's) 2 Alt+A - accesses "Auxiliary" records menu. 2 Alt+D - Toggles to alternate "Displays". 2 Alt+R - Retrieves prices from price records. 2 Alt+S - Send prices to price records. 2 Alt+L - access data-Link to download price quotes into current screen. 2 Alt+M - Mask sub/totals. 2 Alt+G - display pie-chart Graphics. ("F-" in Misc. specs. suppresses "fill") 2 Alt+C - Currency exchange rate import (CT-Global, Display #5 only). 2 Alt+X - eXport to Master list from current position records. 2 Alt+I - Income forecast re-calculation. (Display #2 only, see manual) 2 Alt+U - (CAPTOOL Batch Only) Updates individual portfolio positions for 2 close date and values using prices from current batch position. 2 Alt+Y - Yield % & F/C Income recompute using master list specifications 2 Alt+! - Toggles price retrieval "Disable" flag. When set ("!" next to 2 symbol) DataLink skip record during price retrieval operations. 2 * Position Fields 2 2 T - Security type 2 Symbol - Ticker symbol 2 Descript. - Security Description, "@$" for div/int rate, e.g. "@$1.25" 2 Position - Number of units held 2 Mkt Price - Market price on date of valuation 2 $ Value - Valuation at market price 2 $ Cost - Taxable Cost Basis of security 2 Gains - (Dspl #0) Unrealized gain or loss (in parentheses) 2 Val % - (Dspl #0) Percent of total portfolio 2 Gain % - (Dspl #1) Percent gain over taxable cost basis 2 $/Yr - (Dspl #2) Forecast income/yr (Qty * @$ in Master List Aux Descr.) 2 Yld % - (Dspl #2) Annual dividend or interest percent yield 2 $/U - (Dspl #3) Taxable cost basis per share or unit 2 Beta - (Dspl #3) Security static beta (from Master List record) 2 Accrued - (Dspl #4) Accrued interest (int. rate/dates spec'd in Mstr. List) 2 * Portfolio/Batch Valuation "Alt" Menu 3 3 Alt+A - Accesses Auxiliary record menu. 3 Alt+C - Create valuation or re-compute valuation after transactions modi- 3 fied. Overwrites any valuation of same date but preserves prices. 3 Alt+R - Review existing valuation. Positions are NOT RECALCULATED 3 Alt+D - Delete existing valuation. 3 Alt+B - Set valuation "Base" date. Positions are computed starting with 3 the valuation on the base date and including all subsequent 3 transactions. Default base is day before first transaction. 3 Alt+G - Valuation Graphics (see manual for setting up printer) 3 Alt+M - Multiple valuation recalculation. 3 Alt+T - toggles Tax status. If Tax=On then Est. Tax computed on batch val. 3 Alt+I - Import (See IMPORT.TXT for details) 3 Note 1: When prompted for Create, Review, Delete or Base date, Gray "+" & 3 "-" keys may be used to select dates from table. 3 Note 2: The valuation screen displays up to 64 valuation dates, however 3 more than 64 dates may be created. Use "PgUp", "PgDn" to view 3 these additional records. 3 Note 3: "*" indicates that price data is missing for the indicated date. 3 "." indicates requires "re-Creation" due to transaction edits. * 4 * ROI Computation 5 5 To compute ROI, set the "Mask" record, then execute the "Alt+R" command 5 to initiate the ROI calculation: 5 5 Start Date - ROI initiation date (should be a valuation date). 5 End Date - ROI termination date (should be a valuation date). 5 Symb Mask - Specifies symbol of security to be computed. Setting 5 of "*ALL*****" computes ROI of entire portfolio. 5 T - Specifies security type. If blank then all types used. 5 SIC - Specifies industry code as specified in master list. 5 If blank then all types used. 5 Twt - "Time Weighted". If "On" a time-weighted ROI is computed. 5 Pf Mask - Specifies portfolio to be used (CAPTOOL only). Default is 5 current portfolio. DOS "wildcard" symbols "*" & "?" for 5 multiple portfolios, e.g. "*.*" computes all portfolios. 5 Csh - Currency symbol mask. (CAPTOOL-Global only) 5 5 "Beta" output is of portfolio or security relative to the market index. 5 No beta is displayed if Twt=Off or ROI covers fewer than 12 valuations. 5 "Alt+C" clears the ROI "mask" record, setting Symb. Mask back to "ALL" * Tax Rate Fields 6 6 Mo/Dy/Yr - Date new rates become effective. 6 Hld Prd - Hold period (months) req'd for long term cap. gains. 6 (Use 999 or greater for no long term treatment.) 6 CGRate - Long term capital gains rate (0 .. 1.0 allowed) 6 (Use 1.0 for no long term C.G.) 6 Max Loss - Maximum capital loss deductible from ord. income 6 Tax Rate - Portfolio marginal tax rate (0 .. 1.0) 6 Lng/Sht - Long to Short term weighting ratio 6 Loc Rate - Local tax rate (City & State) 6 Index - Annual price index used to adjust cost bases up for inflation. 6 This is only used if portfolio C.G. Indexing="On" 6 Idx Hld - Min. Period a security must be held to be eligible for 6 cap. gains cost base indexing. * Accounts Fields (Use "Home"/"End" keys to initiate edit) 7 7 Account Name - Name & Address (\= separator, < > = salutation) 7 Phone Number - For auto dial, requires modem 7 Portfolio File - File specification (must be legal DOS filename, i.e. max. 7 8 char. prefix and max. 3 char. extension). 7 Acct. Number - For reports 7 Tax ID Number - For reports 7 Note Field - Hidden field (Use Alt+N to access) 7 7 Client Group "Alt" Menu 7 7 Alt+P - "Prints" records, labels & mail merge (see manual for details) 7 Alt+S - "Sort" by Zip, Acct. #, or Portfolio Filename 7 Alt+D - (or F9 key) Auto dial current client 7 Alt+K - "seeK" record containing key word or key word combination 7 Alt+N - Display Note field for editing 7 Alt+G - "Get" (Load) portfolio indicated in current screen 7 Alt+B - enter "Batch" Valuations module (Captool only) 7 * Master Security List ("Master List") 8 8 The Master Security List is used to store information about a security 8 so it can be automatically or optionally drawn upon by PFROI when it 8 performs computations or generates reports. Fields are used as follows: 8 8 SYMBOL - Used to uniquely identify security. 8 8 Aux. Description - Extended description, may be used to indicate interest 8 & dividend rates and dates and bond maturity dates and redemption prices 8 as in the following examples: 8 8 "@@2/15*4@$5.32" - indicates that a $5.32 annual dividend or interest 8 is paid in 4 quarterly installments (the "*4" indicates this), with 8 the first payment of the calendar year on 2/15. 8 8 "##10/15/94#$100" - indicates that a bond matures on 10/15/94 at a par 8 price of $100/unit. If the price is omitted, 100 is the default. 8 8 "/F-" in Aux. Descrip. --> income is federal tax free. 8 "/L-" in Aux. Descrip. --> income is local tax free. * Master Sec. List (cont'd) 8 8 Cusip - Security "Cusip" number which may be used in lieu of "Symbol" 8 for price retrieval. 8 8 T - Security type. This value will be automatically imported onto 8 position screens when the "Create" valuation command is executed. 8 8 SIC - Industry code. Use first two chararcters of federal "SIC" code. 8 8 "$" - "Cash symbol". Uses to indicate the base denomination of security 8 in multiple currency portfolio. 8 8 Beta- This value will be automatically imported onto position screens 8 when the "Create" valuation command is executed. * Master Sec. List "Alt" Menu 8 8 Alt+S - Sort by symbol, cusip and/or type. 8 Alt+K - seeK record with specified symbol. 8 Alt+D - accesses Distribution records 8 Alt+T - accesses group Type specification records. 8 Alt+! - toggles quote retrieval suppression (! next to symbol indicates 8 quote retrieval suppression is active. 8 Alt+# - toggles quote retrieval by CUSIP # in lieu of symbol. (# next to 8 symbol indicates CUSIP quote retrieval is active. 8 Alt+* - toggles suppression of import to price record on Ctrl+F6 cmd 8 (* next to symbol indicates import to price record is suppressed) * Price Limit Records A A Price Limit records specify both low and high target prices for a A security. If the valuation price falls below the low price or exceeds A the high price an asterisk "*" will appear on the position screen A adjacent to the price field for the security. A A Price Limit Records are local to each portfolio. A * Portfolio Configurations B B The Portfolio Configuration Record allow each portfolio file to be B individually configured for the following parameters: B B Fiscal Year - Date of fiscal year end B Tax Adj - Forces generation of year-end tax adjustment entry. B Loss Carryover- Forces generation of year-end loss carryover entry. B C.G. Indexing - Enables capital gains inflation indexing. B Client Rpts - Specifies reports to be included in client report, B e.g. "ABEMJK[". Note: Including "[" in spec. B shifts account title to right. B Val. Base - "Last"=Last previous valuation date. B "First"=One day prior to first transaction date. B Distribution - Enables automatic insertion of distribution transactions. B Twtd ROI/Beta - Enables time weighted ROI and beta computation. B Beta Index - Specifies Index to be used for beta calculation. B Index - Specifies symbol & description for indices B * CAPTOOL Configurations C C Global configurations apply across all portfolios unless overridden C by local configuration specifications. C C Work File Path - Specifies disk drive/directory to be used for temporary C storage/retrieval of records when DOS base RAM memory is C full. Fastest operation is achieved with RAM disk. C System Mhz - No longer used. C System Sound - Enables/Disables prompt "beep". C Mono HiVideo - Sets "Hi" & "Reverse" video for monochrome displays. C Block Cursor - Enables Block cursor for LCD displays. C File Backup - Enables/Disables creation of "$" backup files. C Decimal Type - Either "." or "," decimal notation. C Amt Dcmls - Decimal places (0..4) displayed for "Amount" values. C Currency Symb - Symbol of base currency used in portfolio. C Date Format - Date display format (Mo/Dy/Yr, Dy-Mo-Yr, Yr.Mo.Dy) C The configurable default input period is 1951-2050; C Warning: See manual before altering Century base year. * PFROI Configurations C C The PFROI Configurations contain the default configuration to which a C portfolio file is set when it is created as a new file. C C Fiscal Year - Date of fiscal year end C Tax Adj - Forces generation of year-end tax adjustment entry. C Loss Carryover- Forces generation of year-end loss carryover entry. C C.G. Indexing - Enables capital gains inflation indexing. C Client Rpts - Specifies reports to be included in client report. C Val. Base - "Last"=Last previous valuation date. C "First"=One day prior to first transaction date. C Distribution - Enables automatic insertion of distribution transactions. C Twtd ROI/Beta - Enables time weighted ROI and beta computation. C Beta Index - Specifies Index to be used for beta calculation. C Misc. Specs - Misc. "Switches" (see manual) C Index - Specifies symbol & description for indices C * PFROI Misc. Specs C C Operative Miscellaneous specs on the PFROI "Configure" menu are: C C F- : Suppress "fill" of allocation plot (CGA & Herc never fill) C T- : Disables automatic Sub-Totaling on position screen C C- : Disables automatic override of portfolio configurations by PFROI C configurations C C+ : (in Portfolio Config record) protects indiv. portfolio config. C from override by PFROI confg. C S+ : "Send price" command on position screen overrides existing prices C in price records. C A+ : Causes bond "accrued" interest to be added to bond valuation. C G- : Forces graphics to be printed from screen (faster) rather than C from memory buffer (higher resolution). C M+ : Automatic update of Master List from Position Records. C P+ : Adds the Current Path to data filenames C X- : disables printer port chkg C C! : forces cost base recomputation C R+ : Sets automatic retrieval of prices from PRICES.STD C * PFROI Reports D D Upon selection of a report from this menu the user is prompted for set-up D specifications required for the selected report. Default values will D generally be provided. "Base" & "End" dates should correspond to existing D valuations. Vertical arrow keys may be used to select alternate dates. D D End/Close Date - Last date of the reporting period desired. D Base/Start Date - Last date of preceding report period. D Fiscal Year End - Used for tax and capital gains reports. D Output Device - "LPT1" for printer port #1, "SCRN" for screen display, D and any unused file name for disk text file output. D If ".WKS" file extension is used, a Lotus-readable D ".WKS" file is created. (Regis PFROI/CAPTOOL only) D D Note: Some reports are user customizable with respect to the fields which D are printed. Depressing the "Ctrl" key plus report selection key D will bring up the customization screen for a report. D * Auxiliary Records E E Auxiliary records contain portfolio supporting data other than E transaction and position records. E E The following Aux. records are local to each portfolio and thus may E be uniquely configured for each portfolio: E E Portfolio Configurations E Tax Rate Table E Limit Prices/Reinvestment specs. E E The remaining Aux. records apply to all portfolios. E * Report Customization F F The report customization screen displays fields available to the user with F each field labeled with a letter "A"-"Z". Some fields may be similar to F others but be of longer length, e.g. " Description " vs. "Descrip". F F The letter sequence in the "Cur. Spec." determines which fields and in F what order they will appear in the report. The "Cur. Spec." may be F modified by making an entry in the "New Spec.". F F Report output is truncated to the maximum output columns specified in the F printer set-up specifications. F * F Some reports recognize "switches" appended to the customization spec. F Use "/" to separate switches from the customization specification. F F Open Lot Report : "D-" or "*" suppresses average lot detail F Capital Gains : "S+" adds subtotal for multiple lot occurences F "D-" suppresses cap. gains distribution reporting F "*" suppresses avg lot detail (same buy date) F ROI by Security : "*=25" displays estimated "partial period" ROIs for F securities with zero opening or closing values when F ROI/Yr is worse than -25% or greater than 100/(1-.25). F If no valid partial period ROI can be computed, or F the limit exceeded and funds added/withdrawn exceed F 50% of the value, "******" is displayed. F *